Tabela ChronicDisease

Definicja tabeli ChronicDisease

Name

ChronicDisease

Code

ChronicDisease

Comment

Dane chorób przewleklych


Lista kolumn tabeli ChronicDisease

Name

Code

ChronicDiseaseID

ChronicDiseaseID

PersonID

PersonID

DiagnosisDate

DiagnosisDate

Diagnosis

Diagnosis

ICD10

ICD10

Author

Author

Comments

Comments

InsertingPerson

InsertingPerson

InsertDate

InsertDate

LastModifiedPerson

LastModifiedPerson

LastModifiedDT

LastModifiedDT


Kolumna ChronicDiseaseID tabeli ChronicDisease

Definicja kolumny ChronicDiseaseID tabeli ChronicDisease

Name

ChronicDiseaseID

Code

ChronicDiseaseID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna PersonID tabeli ChronicDisease

Definicja kolumny PersonID tabeli ChronicDisease

Name

PersonID

Code

PersonID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna DiagnosisDate tabeli ChronicDisease

Definicja kolumny DiagnosisDate tabeli ChronicDisease

Name

DiagnosisDate

Code

DiagnosisDate

Data Type

DATE

Mandatory

No

Comment

Data diagnozy


Kolumna Diagnosis tabeli ChronicDisease

Definicja kolumny Diagnosis tabeli ChronicDisease

Name

Diagnosis

Code

Diagnosis

Data Type

NUMBER(10)

Mandatory

No

Comment

Diagnoza


Kolumna ICD10 tabeli ChronicDisease

Definicja kolumny ICD10 tabeli ChronicDisease

Name

ICD10

Code

ICD10

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna Author tabeli ChronicDisease

Definicja kolumny Author tabeli ChronicDisease

Name

Author

Code

Author

Data Type

NUMBER(10)

Mandatory

Yes

Comment

Osoba wpisujaca


Kolumna Comments tabeli ChronicDisease

Definicja kolumny Comments tabeli ChronicDisease

Name

Comments

Code

Comments

Data Type

VARCHAR2(200)

Mandatory

No

Comment

 


Kolumna InsertingPerson tabeli ChronicDisease

Definicja kolumny InsertingPerson tabeli ChronicDisease

Name

InsertingPerson

Code

InsertingPerson

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna InsertDate tabeli ChronicDisease

Definicja kolumny InsertDate tabeli ChronicDisease

Name

InsertDate

Code

InsertDate

Data Type

DATE

Mandatory

Yes

Comment

 


Kolumna LastModifiedPerson tabeli ChronicDisease

Definicja kolumny LastModifiedPerson tabeli ChronicDisease

Name

LastModifiedPerson

Code

LastModifiedPerson

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna LastModifiedDT tabeli ChronicDisease

Definicja kolumny LastModifiedDT tabeli ChronicDisease

Name

LastModifiedDT

Code

LastModifiedDT

Data Type

DATE

Mandatory

Yes

Comment

 


Lista kluczy tabeli ChronicDisease

Name

Code

Primary

Identifier_1

Identifier_1

X


Klucz Identifier_1 tabeli ChronicDisease

Definicja klucza Identifier_1 tabeli ChronicDisease

Name

Identifier_1

Code

Identifier_1

Primary

Yes

Comment